1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33 |
<?php
#*********************************************************************
# Description:
# Deleting data from a SQL Anywhere database can be
accomplished by
# performing a sasql_query() call to execute a DELETE statement.
# The sasql_query() function prepares and executes the DELETE
# statement identified by the connection that is passed
in.
#
#*********************************************************************
# Connect using the default user ID and
password
$conn = sasql_connect ( "UID=DBA;PWD=sql" ) ;
if
( !
$conn ) {
echo
"Could not connect! \n " ;
echo sasql_error ( ) ;
exit (
) ;
}
echo "Connected
successfully! \n "
;
# Execute a DELETE statement
$stmt = 'DELETE FROM my_test_table WHERE name = \' John \' ' ;
$result = sasql_query ( $conn ,
$stmt )
;
# Report any errors
if ( !
$result ) {
echo
"sasql_query failed!" ;
} else {
echo "query
completed successfully \n
" ;
}
sasql_close ( $conn ) ;
?>
|
BACK : 技術情報（サンプルコード＆ユーティリティ）のトップページ
